Easy2Siksha.com
GNDU Question Paper-2022
Bachelor of Business Administration
B.B.A 1
st
Semester
Computer Application for Business-I
Time Allowed: Three Hours Maximum Marks: 35
Note: Attempt Five questions in all, selecting at least One question from each section. The
Fifth question may be attempted from any section. All questions carry equal marks.
SECTION-A
1. What is difference between Internal and External memory? What is difference between
RAM and ROM?
2. Which are different types of Software? What does an Interpreter do?
SECTION-B
3. What is a window in Windows OS? Which are different parts of a window?
4. What is an Operating System? Which are different types of Operating System ?
SECTION-C
5. Explain the features of MS-Word as a word processor.
6. Explain how can you perform following operations in MS-Word:
(a) Creating lists and numbering
Easy2Siksha.com
(b) Adding Header and Footer
(c) Finding and Replacing Text.
SECTION-D
7. Which are different types of Graphs available in MS-Excel?
8. Which are various views of slides available in MS-PowerPoint?
GNDU Answer Paper-2022
Bachelor of Business Administration
B.B.A 1
st
Semester
Computer Application for Business-I
Time Allowed: Three Hours Maximum Marks: 35
Note: Attempt Five questions in all, selecting at least One question from each section. The
Fifth question may be attempted from any section. All questions carry equal marks.
SECTION-A
1. What is difference between Internal and External memory? What is difference between
RAM and ROM?
Ans: The backpack and the basement
Picture a student getting ready for school. In the backpack go the day’s essentials: a
notebook, a few pens, the lunchboxeverything needed right now and easy to grab. Down
in the house’s basement sit old report cards, photo albums, and boxes of books: safe for
years, but not something you carry around. Computers are just like this. They keep “right
now” stuff in fast, handy places, and store “for later” stuff in big, slower, safer places. That’s
Easy2Siksha.com
the heart of internal vs external memoryand it also sets the stage for understanding RAM
vs ROM.
Memory at a glance comparison table
Attribute
Internal memory
External memory
What it is
Memory inside the computer
system used directly by the CPU
(e.g., RAM, cache, ROM)
Auxiliary storage used for long-term
keeping of data (e.g., HDD, SSD, USB
drives, memory cards)
Speed
Very fast (nanoseconds to
microseconds)
Slower (microseconds to milliseconds)
Volatility
Often volatile (RAM); some parts
non-volatile (ROM)
Non-volatile; retains data without power
Capacity
Smaller to moderate
Large to massive
Cost per
GB
Higher
Lower
CPU
access
Directly addressable by CPU
Accessed via I/O controllers; not directly
by CPU
Typical
use
Running programs, active data,
firmware close to the CPU
Saving files, backups, media libraries,
archives
Portability
Usually fixed inside device
Often removable/portable
Sources: Common computer architecture distinctions.
Attribute
RAM
ROM
Full form
Random Access Memory
Read Only Memory
Nature
Volatile working memory for
current tasks
Non-volatile memory storing permanent
instructions/data
Can it be
changed?
Yes, read/write happens
constantly while running
Typically not during normal use; some
types can be rewritten with special
methods
Speed
Very fast (especially
cache/SRAM; DRAM is fast
too)
Generally slower than RAM, but faster than
many external storages
Typical
contents
Open apps, OS data in use,
variables, buffers
Boot firmware (BIOS/UEFI), device
firmware, critical startup code
Easy2Siksha.com
Data on
power off
Lost
Retained
Examples
DRAM, SDRAM, DDRx, SRAM
(cache)
Mask ROM, PROM, EPROM, EEPROM, Flash
used as firmware storage
Internal and external memory explained simply
Where it sits: Internal memory lives close to the CPU on the motherboard or even
inside the processor chip (like cache). External memory lives on separate storage
deviceshard drives, SSDs, USB sticks, SD cards, optical discsconnected through
ports or internal cables.
What it’s for: Internal memory handles the “live action.” It keeps the operating
system’s active parts, your open program code, and the data your CPU is juggling
right now. External memory is your library and vault: documents, videos, backups,
and software installers, saved for hours, months, or years.
Why the speed difference matters: CPUs work at breathtaking speeds. To keep up,
they need lightning-fast memory (cache, RAM) so instructions and data arrive in
time. External memory is optimized for capacity and durability; it doesn’t have to
match CPU speed because the system fetches from it less frequently and often in
larger chunks.
Volatile vs non-volatile: Most internal working memory (RAM) forgets everything
when power is offjust like your backpack emptied at the end of the day. External
memory remembers your files even if you unplug it, like boxes safely stored in the
basement.
Cost and capacity trade-off: Making memory super-fast is expensive. That’s why
internal memory tends to be smaller but quicker, while external memory offers
massive space at a much lower cost per gigabyte.
Direct access vs through controllers: Internal memory is wired for the CPU to read
and write directly, minimizing delay. External memory is accessed through storage
controllers and buses (like SATA, NVMe, USB), which adds steps and latency but
enables huge, flexible storage.
RAM and ROM explained simply
RAM as your working desk: RAM is the big, clean desk where you lay out your books
and notes while studying. You constantly move things around: open a file, edit a
photo, run a gameRAM holds these active pieces so the CPU can grab them
instantly. When you shut down, the desk is cleared.
ROM as your instruction card: ROM is like a laminated card taped to your desk with
essential instructions: “How to start the computer.” It contains firmwaretiny
programs the computer uses to wake up, check its components, and hand control to
Easy2Siksha.com
the operating system. Because this information must be dependable, it’s stored in a
way that doesn’t vanish when power goes off.
Volatility and mutability:
o RAM: Volatile and read/write. Data changes millions of times per second.
Lose power, lose contents.
o ROM: Non-volatile and, in the classic sense, read-only. Modern ROM variants
(EEPROM/Flash) can be updated carefully (e.g., a BIOS/UEFI firmware
update), but not during everyday use.
Types you’ll hear about:
o RAM types:
DRAM: The standard system memory in sticks; high capacity,
refreshed constantly.
SRAM: Faster and costlier, used for CPU caches (L1/L2/L3).
o ROM types:
Mask ROM/PROM: Written once at factory or once by the device
maker.
EPROM: Erasable with UV light; rare today.
EEPROM/Flash: Electrically erasable; used for firmware and
embedded systems.
Speed and role: RAM feeds the CPU at high speed to keep programs responsive.
ROM doesn’t compete on speed with RAM; its job is reliabilitybeing ready with the
right startup code every time.
What happens at power-on: The CPU looks to ROM-based firmware first. That
firmware tests hardware, initializes components, and then loads the operating
system from external memory (SSD/HDD). Once the OS starts, it pulls code and data
into RAM, and you’re off and running.
How internal vs external, and RAM vs ROM, fit together
Boot sequence choreography:
o ROM (internal, non-volatile): Provides the first instructions so a “blank” CPU
knows what to do.
o External storage (non-volatile): Holds the operating system and your files.
o RAM (internal, volatile): Becomes the active workspace, holding the OS
kernel, apps, and current data.
Easy2Siksha.com
o Cache (internal, ultra-fast): Keeps the hottest data right next to the CPU
cores.
Performance pipeline: The closer to the CPU, the faster and smaller the memory.
Data flows from external storage into RAM, then into CPU caches, and finally into the
CPU registers. Each step trades capacity for speed to keep the processor busy and
your apps snappy.
Why phones say “internal storage”: In everyday language, especially on phones,
“internal memory” often means built-in flash storage where apps and photos live. In
computer science terms, that’s external/secondary storage because it’s non-volatile,
slower than RAM, and accessed via controllers. Context matters; both uses exist.
Common confusions cleared up
“ROM means you can never change it.” Classic ROM is fixed, but many devices use
EEPROM or Flash for firmware, which can be updated carefully. It’s “read-mostly” in
practice, not edited constantly like RAM.
“SSD is internal memory, right?” An SSD can be inside your PC, but functionally it’s
external/secondary storage: non-volatile, large, and accessed via I/O. Internal in
location, external in role.
“More RAM or more storage—what speeds up my PC?”
o More RAM: Helps performance if you’re running out, reducing slow swaps to
disk and keeping more active data close to the CPU.
o More storage or faster SSD: Helps with load/save times and file transfers, but
won’t replace the need for sufficient RAM.
“Will I lose my work if power cuts?” Unsaved work in RAM is lost. Saved files on
external storage remain. Autosave features copy snapshots from RAM to storage to
protect you.
A single story to remember it by
Think of your computer as a student in motion. The backpack (RAM) carries the day’s
essentialsfast, light, but emptied every night. The laminated schedule in the front pocket
(ROM) never changes, guiding the morning routine. Back home, the basement shelves
(external storage) keep every book and binder safe for months and years. And the desk at
school (cache and registers) is where the fastest scribbling happens. Together, they make
learning smooth: quick access for now, reliable memory for later.
Direct answers you can use in exams
Difference between internal and external memory: Internal memory is the
computer’s fast, directly accessible working and control memory (RAM, cache, ROM)
used by the CPU for immediate tasks; it’s smaller, costlier per GB, and often volatile.
External memory is non-volatile auxiliary storage (HDD, SSD, USB, SD, optical, tape)
Easy2Siksha.com
used to keep data long term; it’s larger, cheaper per GB, slower, and accessed
through I/O.
Difference between RAM and ROM: RAM is volatile, high-speed, read/write working
memory that holds active programs and data; it loses contents when power is off.
ROM is non-volatile, read-only (or read-mostly) memory that stores essential
firmware and startup instructions; its contents persist without power and change
rarely, if at all.
With that, you’ve got the big picture and the fine lines: what the computer needs right now,
what it must never forget, and where it keeps everything else safe.
2. Which are different types of Software? What does an Interpreter do?
Ans: Night shift at the digital workshop
After sunset, a quiet workshop lights up. Tools hang on the walls, each with a label: some
keep the place runningoiling gears, powering lightswhile others craft beautiful things
people will use tomorrow. A seasoned foreman walks the floor, translating designers’
sketches into live instructions for the machines, guiding them step by step. That workshop is
your computer, those labels are kinds of software, and the foreman you just pictured
that’s what an interpreter does.
The main types of software
Think of software as roles in a team. Each category exists because computers need both a
stable foundation and creative output.
System software:
o Operating system (OS): The conductor. It manages hardware, memory, files,
and processes. Examples include Windows, macOS, Linux, Android, and iOS.
o Kernel: The OS core that speaks directly to hardware, schedules CPU time,
and handles memory protection.
o Device drivers: Specialized translators that let the OS control specific
hardware like printers, graphics cards, and network adapters.
o Utilities: Maintenance tools for disk cleanup, backup, antivirus, compression,
and system diagnostics.
o Firmware: Low-level, non-volatile programs etched into devices (like
BIOS/UEFI in PCs or the microcode in keyboards). It boots systems and
controls hardware reliably even without an OS.
Application software:
Easy2Siksha.com
o General-purpose apps: Everyday tools such as word processors,
spreadsheets, browsers, media players, and email clients.
o Creative and professional tools: Video editors, CAD software, DAWs for
music, photo editors, IDEs for coding.
o Vertical/industry-specific apps: Hospital management systems, airline
reservation systems, banking core platforms, ERP/CRM suites for business.
o Mobile and web applications: From messaging and maps to online learning
and e-commercedelivered through app stores or browsers.
o Games and interactive media: Entertainment that mixes graphics, physics,
sound, and storytelling.
o Software-as-a-Service (SaaS): Apps delivered via the cloud, updated
centrally, accessed through a subscription (e.g., collaborative docs, CRM,
analytics dashboards).
Programming software (developer tools):
o Compilers: Translate high-level code (like C/C++) into machine code ahead of
time, producing executables.
o Interpreters: Execute code directly or via an intermediate form at runtime
(Python, Ruby, JavaScript engines).
o Assemblers: Convert assembly language into machine code.
o Linkers/build tools: Stitch together compiled pieces and libraries into a final
program.
o Debuggers and profilers: Let developers step through code, inspect variables,
and measure performance.
o IDEs and editors: Integrated environments that combine editing, building,
testing, and version control.
Middleware:
o Definition: Glue software that helps different applications or services talk to
each other across networks or platforms.
o Examples: Message brokers (like queues), application servers, database
connectors, API gateways, and service meshes. Middleware quietly enables
scalability, security, and integration.
Embedded software:
o Where it lives: Inside appliances, cars, medical devices, and IoT gadgets.
Easy2Siksha.com
o Traits: Tailored for specific hardware, resource-constrained, often real-time.
It blurs with firmware: both live close to the metal to control devices safely
and efficiently.
By licensing and distribution:
o Open-source: Source code is available to view, modify, and share under
licenses (e.g., GPL, MIT).
o Proprietary: Owned by a company; source is closed, licensed under terms of
use.
o Freeware and freemium: Free to use; freemium adds paid extras.
o Shareware and trials: Try-before-you-buy models.
o Public domain: No exclusive rights; free for any use.
By deployment model:
o On-premise: Installed on local machines or servers you control.
o Cloud-native: Built for the cloud, scaling dynamically using containers and
microservices.
o Hybrid: Splits workloads across on-prem and cloud for flexibility and
compliance.
Each category solves a distinct problem: stability, creation, connection, control, and
delivery. Together, they turn lifeless hardware into a living system.
What an interpreter does
At heart, an interpreter’s job is simple: take human-friendly instructions and make the
computer act on them immediately. But inside, there’s elegant choreography.
Reads and understands your code: The interpreter ingests your program’s text,
breaks it into tokens (words and symbols), and parses it into a structured form (often
an Abstract Syntax Tree). This turns “what you wrote” into “what you meant” in a
format the machine can navigate.
Turns meaning into actions: Instead of producing a standalone executable ahead of
time, the interpreter walks that structure and performs each step nowcreating
variables, running loops, calling functions, and interacting with the operating system
as needed.
Uses an intermediate representation (IR): Many interpreters translate to a compact
internal form (like bytecode) for speed and portability. Python compiles .py to .pyc
(bytecode) for the Python Virtual Machine; JavaScript engines build bytecode and
optimize hot paths; Lua and Ruby also use bytecode. This IR is easier to execute
quickly than raw text.
Easy2Siksha.com
Runs on a virtual machine (often): A virtual machine (VM) is a tiny, specialized
computer inside your computer that understands the interpreter’s bytecode. It
provides a consistent environment across different operating systems, which is why
a Python script can run on Windows, macOS, or Linux with the same interpreter.
Optimizes on the fly: Modern engines include Just-In-Time (JIT) compilers that watch
which parts of your code run frequently and then translate those hot sections into
fast machine code at runtime. JavaScript browsers, Java’s HotSpot, and PyPy do this
to shrink the gap with compiled languages.
Keeps interaction instant: Interpreters power REPLs (ReadEvalPrint Loops). You
type a line, it executes immediately, and the result appears. This is invaluable for
learning, debugging, data exploration, and rapid prototypingone small step at a
time.
Handles errors as you go: Because execution happens now, the interpreter can stop
at the precise line with a problem and tell you whymissing parentheses, wrong
variable name, type mismatchoften with a stack trace that points to the exact
spot.
Manages the runtime world: Interpreters come with a runtime system: memory
management (often garbage collection), built-in types (strings, lists, maps),
exceptions, modules, and foreign-function interfaces for calling native libraries.
Contrasts with a compiler and an assembler:
o Compiler: Translates the entire program to machine code before running.
Fast execution later, but a separate build step first.
o Interpreter: Executes via reading or bytecode, no separate build; great for
immediacy.
o Assembler: Converts low-level assembly to machine code, one-to-one with
hardware instructions.
Typical use cases:
o Scripting and automation: Shell scripts, Python utilities, task runners glue
systems together.
o Web front-ends: Browsers interpret JavaScript to animate pages and handle
interactions.
o Data science and education: Notebooks let you run code in cells, visualize
instantly, and explain as you go.
o Configuration and embedded mini-languages: Many tools expose scripting
interpreters for customization.
Strengths and trade-offs:
Easy2Siksha.com
o Strengths: Rapid iteration, portability across platforms, excellent debugging
and interactivity.
o Trade-offs: Historically slower than ahead-of-time compiled code;
performance improves with JIT, but tight inner loops in compute-heavy tasks
may still favor compiled approaches or native extensions.
A quick narrative to lock it in
Imagine the workshop again. A compiler is like a factory that takes your blueprint, builds the
entire machine overnight, and delivers a finished product in the morningready to run fast.
An interpreter is the foreman standing by the machine right now, reading the blueprint
aloud step by step: “Drill here, tighten there, test now.” You can change a line, and the
foreman adapts instantly. If something breaks, you know the exact step. Both make the
machine, but the rhythm and feedback are different.
How the categories and the interpreter fit together
Where interpreters live: Interpreters are part of programming software. They sit
atop system software (the OS and drivers) and often ship as application software
(like a Python distribution or a browser). Middleware or embedded systems may
embed interpreters to allow scripting inside larger platforms.
Why categories matter: System software gives interpreters a stage (processes,
memory, files). Interpreters give application developers a brush for fast painting.
Applications, in turn, deliver the artwork to users. Without the system layer, nothing
runs; without interpreters and compilers, nothing new is created; without
applications, users see no value.
Cloud era twist: In cloud platforms, interpreters run inside containers or serverless
functions, spinning up on demand. The same portability that makes interpreters
great on laptops makes them ideal for elastic infrastructure: write once, run
anywhere the interpreter exists.
Exam-ready summary
Different types of software:
o System software: OS, kernel, device drivers, utilities, firmwarefoundation
that manages hardware and resources.
o Application software: General-purpose, creative, industry-specific, games,
mobile/web apps, SaaStools users interact with to do tasks.
o Programming software: Compilers, interpreters, assemblers, linkers,
debuggers, IDEstools for building other software.
o Middleware and embedded: Glue between systems, and specialized
software inside devices.
Easy2Siksha.com
o Licensing and deployment: Open-source vs proprietary; on-premise vs
cloudhow software is shared and delivered.
What an interpreter does:
o Core role: Executes high-level code by parsing it, often turning it into
bytecode, and running it immediately via a VM and runtime.
o Pros: Instant feedback, portability, strong debugging, great for scripting and
learning.
o Cons: Usually slower than ahead-of-time compilation; mitigated by JITs and
optimized engines.
o Examples: Python, Ruby, JavaScript (in browsers), shells, and many domain-
specific languages.
With these pieces in place, the “who does what” of software becomes clear: the foundation
keeps the lights on, the tools craft the products, and the interpreter is the on-call foreman
turning human ideas into living actionsone precise step at a time.
SECTION-B
3. What is a window in Windows OS? Which are different parts of a window?
Ans: The study table by the window
It’s a rainy evening. You sit at a study table by a real window, watching drops race each
other down the glass. On the table are neat frames holding different tasks: one frame for
your notes, one for a map, one for a story you’re writing. You reach out and slide a frame a
little to the left, make another bigger, and put the most important one right in front. That’s
exactly how Windows OS treats a “window”: a framed view that lets you work with one
program’s world while keeping others close, visible, and movableso you can focus, switch,
and organize your digital desk with ease.
What a window is in Windows OS
A window is a rectangular area on your screen that belongs to a program. It’s the program’s
room, with its own door, nameplate, and controls. Inside this rectangle, the application
shows its contentdocuments, web pages, folders, imagesand gives you tools to act on
that content.
Windows OS manages these rectangles so you can open many at once, bring one to the
front, send one to the back, minimize it to the taskbar, or make it stretch across the screen.
This is the heart of multitasking: each window is a focused space for a specific task, and you
arrange these spaces to match your flow. The OS also remembers which window is “active”
(has focus), so your keyboard and mouse act on the right one.
Easy2Siksha.com
Why windows matter
Without windows, your PC would feel like a single hallwayone program at a time, no quick
compare, no side-by-side work. With windows, your screen becomes a sorting table. You
can read a PDF while typing notes, drag files from a folder into an email, or watch a tutorial
as you follow steps in another app. The frame gives shape to attention: start, stop, switch,
and resume without losing your place.
The anatomy of a typical window
When you look closely, a window has recognizable parts. Each part has a job, like the pieces
of a book: cover, title, margins, page numbers, and text. Here’s a clear tour, from top to
bottom and around the edges.
Title bar: The strip at the top showing the window’s name—usually the document
title or page name plus the app’s name. It’s also your handle: click-and-drag here to
move the window. Double-clicking often toggles between maximized and restored
sizes.
App icon and system menu: On the far left of the title bar, many apps show a small
icon. Right-clicking it (or pressing Alt + Space) opens the system menu: Move, Size,
Minimize, Maximize, and Close. It’s a keyboard-friendly control panel for the
window’s frame.
Caption buttons (Minimize, Maximize/Restore, Close): On the far right of the title
bar live three buttons. Minimize sends the window to the taskbar. Maximize fills the
screen; Restore brings it back to its previous size. Close ends the window (and often
the document or app session).
Menu bar or app menu: Older or classic apps show File, Edit, View, etc. as text
menus. Modern apps may use a single app button or a hamburger icon that opens a
menu of commands. Either way, this is your command catalog.
Ribbon or toolbar/command bar: Many Microsoft and other apps show a ribbon: a
wide set of labeled buttons grouped by task (Home, Insert, View). Others use a
simpler toolbar or command bar with icons and drop-downs. These are quick-access
tools for the most common actions.
Tab bar (if present): Browsers, code editors, and some document apps let you open
multiple items in the same window. Each tab is a mini-title for a subpage or file,
making one window hold several workspaces.
Address bar or breadcrumb (File Explorer and browsers): In File Explorer, the
breadcrumb shows your current folder path and lets you jump to any level with a
click. In browsers, the address bar is where you type web URLs and search terms. It’s
your location line and teleport.
Search box: Many windows include a built-in search field to find words, files, or
settings within the app. It narrows big spaces down to the exact item you need.
Easy2Siksha.com
Navigation pane (side pane): The left side in apps like File Explorer or email clients
lists places (Quick Access, This PC, Inbox folders, favorites). Think of it as your table
of contents to hop between sections fast.
Content area (client area): This is the main canvas where the app’s work happens:
the text of your document, the cells of your spreadsheet, the page of your website,
the photos in a gallery. Everything else exists to support this core.
Scroll bars (vertical and horizontal): When content is bigger than the window, scroll
bars let you move through it. You can drag the thumb, click the track, or use the
mouse wheel and touchpad gestures.
Status bar: A thin bar at the bottom that whispers useful facts: page numbers, word
count, zoom level, caps lock indicators, or connection status. It keeps you oriented
without stealing attention.
Borders and corners (resize grips): The edge of a window is draggable. Pull any
border to make the window wider or taller; pull a corner to resize both at once. This
is how you tailor the frame to fit the task.
Splitters and panes (inside the content): Some apps let you split the viewtwo
documents side by side or a preview next to a list. A draggable splitter bar lets you
resize these internal panes.
Tooltips and infobars: Hover over a button to see a small tooltip with its name or
shortcut. Some apps show an infobar below the toolbar for alerts like “Read-only” or
“Updates available.”
Dialog boxes and modals (special windows): When an app needs a decisionSave
changes? Choose a folder?it opens a dialog window. A modal dialog blocks
interaction with the parent window until you respond (OK, Cancel, Apply). A
modeless dialog stays open while you keep working.
Context menu (right-click menu): Right-click inside many parts of a window to see
commands tailored to that spot—on text, you’ll see copy/paste; on a file, you’ll see
open, rename, properties. It’s the shortest route to relevant actions.
Help and feedback affordances: A small question mark, feedback icon, or F1
shortcut connects you to help pages, tips, or diagnostics. This is your lifeline when
you’re stuck.
Note: The taskbar button and thumbnail preview are not parts of the window itself; they live
outside, but they represent and control the window (switching, peeking, or closing from the
thumbnail).
How the parts work together while you work
A typical session flows like this: you spot the window you need on the taskbar, click it to
bring it forward (now it has focus). You grab the title bar and park it on the left half of your
Easy2Siksha.com
screen; Windows’ snap feature helps it click into place. In the content area, you scroll with
the wheel, glance at the status bar to confirm word count, and tap a ribbon button to
format text. When a save prompt appears as a dialog box, you choose a folder from the
navigation pane, type a name in the dialog’s input field, and press Enter. Every part is a
small control, but together they let you steer smoothly.
Variations across apps and versions
Windows has evolved, and so have window designs:
Classic vs. modern UI: Classic apps use menu bars and toolbars; modern apps prefer
ribbons, command bars, and cleaner title bars. Some merge the title bar with a tab
bar to save space.
Compact title bars: Certain apps hide extra controls in a single menu icon. Others
add a search box or account button right in the title area to bring frequent actions
closer.
Tabs in more places: Beyond browsers, code editors and terminals embrace tabs;
File Explorer now supports tabs too. One window can host many siblings while still
acting like a single, movable unit.
Touch and pen support: On touchscreens, window borders are easier to grab, and
scroll bars auto-hide until needed. Controls have more spacing so your finger finds
them without mistakes.
Snap and layouts: Hovering the maximize button presents layout choices that
arrange windows in neat grids. Not strictly a “part” of the window, but an interaction
that uses existing parts (caption buttons and borders) to fit windows together like
tiles.
A tiny story to anchor the idea
Picture your screen as a city street at night. Each lit window in the buildings shows a
different scene: a chef plating dishes, a writer drafting lines, a coder debugging. You can
step to any window, watch, and work. Pull the blinds (minimize), throw the shutters open
(maximize), or close for the day. The frame doesn’t cook, write, or codethe people inside
do. But without the frame, you couldn’t see in or keep the scenes separate. That’s how a
window serves the app inside it.
Practical tips tied to parts
Move and arrange: Drag the title bar to place the window; use Windows key + Arrow
keys to snap left, right, or maximize. This pairs windows quickly for comparison.
Resize precisely: Grab borders or corners; hold Shift for symmetric resize in some
apps; check the content’s wrap in the status bar to keep things readable.
Navigate faster: Use the address/breadcrumb bar to jump levels in File Explorer, and
the search box to filter long lists instantly.
Easy2Siksha.com
Use context wisely: Right-click where you need an action; the menu changes based
on what you clicked, saving time hunting in menus.
Control clutter: Tabs keep related items together; if an app offers split panes, use
them to compare two parts of one project without opening another window.
Exam-ready recap
Definition: A window in Windows OS is a rectangular, movable, resizable frame that
displays a program’s interface and content, letting you interact with that program
while multitasking with others.
Core parts:
o Title bar: Window name and drag handle.
o App icon/system menu: Quick frame controls via Alt + Space.
o Caption buttons: Minimize, Maximize/Restore, Close.
o Menu bar/app menu: Command categories.
o Ribbon/toolbar: Buttons for common actions.
o Tab bar: Multiple items in one window.
o Address/breadcrumb bar: Current location (Explorer/web).
o Search box: Find within the app.
o Navigation pane: Jump between sections.
o Content area (client area): Main work canvas.
o Scroll bars: Move through large content.
o Status bar: Live info and indicators.
o Borders/corners: Resize controls.
o Splitters/panes: Side-by-side views.
o Dialog boxes: Modal/modeless prompts for decisions.
o Context menu: Right-click actions tailored to location.
If you remember the study table by the real window, you’ve got it: each app lives in its own
frame. You arrange those frames to suit the task, and each part of the frame is a handle that
helps you think less about the computer and more about the work inside.
Easy2Siksha.com
4. What is an Operating System? Which are different types of Operating System ?
Ans: The stationmaster at the junction
Picture a busy railway junction at dawn. Trains rumble in from every direction, platforms fill,
signals blink. One person watches the whole board, assigns tracks, times departures, and
prevents collisions. You don’t see them, but without that stationmaster, everything jams. In
your computer, the Operating System (OS) is that invisible stationmaster. It decides which
program gets the “track” (CPU), where passengers (data) wait (memory), which train gets
priority (scheduling), and how goods move safely between stations (files, devices,
networks). When the OS does its job, the city wakes smoothly; when it doesn’t, everything
stalls.
What an operating system is
An operating system is the fundamental system software that manages hardware resources
and provides common services to application programs. It sits between your apps and the
machine’s electronics, turning complex hardware into friendly, reliable tools you can use.
Resource manager: The OS allocates and reclaims the CPU, memory, storage, and
I/O devices so programs don’t fight over them.
Abstraction layer: It turns raw hardware into simple interfacesfiles instead of disk
sectors, windows instead of pixels, sockets instead of wires.
Coordinator and protector: It schedules work, isolates processes for stability, and
enforces permissions so one app can’t crash or spy on another.
Service provider: It offers shared capabilitiesfile systems, networking stacks, user
accounts, device drivers, security, and user interfaces.
In short: the OS is the rulebook, the referee, and the logistics team for everything your
computer does.
What the operating system actually does
Process and CPU management:
o Scheduling: Decides which process/thread runs now using algorithms (round
robin, priority, multilevel queues).
o Context switching: Saves the state of one task and restores another so
multitasking feels seamless.
o Interprocess communication (IPC): Pipes, message queues, shared memory,
and signals let programs talk safely.
Memory management:
o Virtual memory: Gives each process its own address space, mapping it to
physical RAM and, if needed, temporary storage.
Easy2Siksha.com
o Paging/segmentation: Moves memory in blocks, keeping hot data close and
cold data on disk.
o Protection: Prevents processes from reading/writing each other’s memory.
Storage and file systems:
o File and directory abstractions: Create, read, write, delete, and organize data
with names and paths.
o Buffering and caching: Speed up reads/writes and reduce wear on physical
media.
o Permissions: Control who can access or change which files.
Device and I/O management:
o Device drivers: Tiny translators that let the OS control printers, GPUs,
keyboards, disks, and more.
o I/O scheduling: Orders operations for fairness and throughput.
o Plug-and-play: Detects and configures new devices.
Security and user management:
o Authentication and authorization: Accounts, passwords, tokens, and access
control lists.
o Isolation and sandboxing: Contain apps and services to limit damage if
something misbehaves.
o Auditing: Logs events for diagnostics and compliance.
Networking:
o Protocol stacks: Implements TCP/IP, DNS, HTTP plumbing so apps can
communicate.
o Sockets APIs: Simple calls to connect programs across machines.
o Firewalls and routing: Control traffic and protect systems.
User interface:
o Shells and GUIs: Command lines for precise control; windows, icons, menus,
pointers, and touch for visual interaction.
o Accessibility: Screen readers, high-contrast modes, magnifiers, and input
alternatives.
Easy2Siksha.com
Types of operating systems
There are many ways to classify OSs. The most useful approach for exams is by how they
handle users, tasks, timing, and hardware. Below is a clear map with short notes and
examples.
By job scheduling and user interaction
Batch operating systems:
o Idea: Process jobs in groups with little to no user interaction during
execution.
o Use: Large, repetitive tasks (historical mainframes, modern batch clusters).
o Benefit: High throughput; efficient for long jobs.
o Trade-off: Poor interactivity; delay between submit and result.
Time-sharing (multitasking) systems:
o Idea: Many users share one machine; the CPU rapidly switches between tasks
to give each a quick slice.
o Use: University timesharing systems, modern desktops and laptops.
o Benefit: Interactive computing; responsiveness.
o Trade-off: Requires careful scheduling to avoid lag.
By the nature of timing constraints
Real-time operating systems (RTOS):
o Idea: Meet strict deadlines for tasks that interact with the physical world.
o Hard real-time: Missing a deadline is unacceptable (airbag controllers,
pacemakers, industrial robots).
o Soft real-time: Occasional misses degrade quality but aren’t catastrophic
(multimedia streaming).
o Benefit: Predictability; bounded latency.
o Trade-off: Often limited features to ensure determinism.
By hardware utilization
Multiprogramming systems:
o Idea: Keep several programs in memory so the CPU always has work while
others wait on I/O.
o Benefit: Better CPU utilization than running one job at a time.
Easy2Siksha.com
Multiprocessing systems:
o Idea: Use multiple CPUs/cores to execute tasks in parallel.
o Symmetric multiprocessing (SMP): All cores are peers under one OS image.
o Asymmetric multiprocessing: Specific cores have specialized roles.
o Benefit: Throughput and scalability.
Distributed operating systems:
o Idea: Coordinate multiple machines to appear as one coherent system.
o Use: Clusters for scientific computing; fault-tolerant services.
o Benefit: Resource sharing and reliability; scale out.
o Trade-off: Complex synchronization and failure handling.
Network operating systems:
o Idea: Focus on sharing resources over a network (file/print servers, directory
services).
o Examples: Windows Server, UNIX variants with NFS/SMB services.
o Benefit: Centralized management and collaboration.
By device form and purpose
Embedded operating systems:
o Idea: Tailored for specific hardware, small footprint, often real-time.
o Use: Appliances, cars, routers, sensors, set-top boxes.
o Examples: FreeRTOS, VxWorks, Zephyr, embedded Linux.
o Benefit: Efficiency and reliability on constrained devices.
Mobile operating systems:
o Idea: Designed for touch, sensors, radios, and app sandboxes.
o Examples: Android, iOS.
o Benefit: Power management, security, app ecosystems.
Desktop/laptop operating systems:
o Idea: Rich GUIs, broad hardware support, productivity focus.
o Examples: Windows, macOS, desktop Linux distributions.
o Benefit: General-purpose computing and peripherals.
Easy2Siksha.com
Server and mainframe operating systems:
o Idea: Maximize reliability, concurrency, and networking.
o Examples: Windows Server, Linux server distros, UNIX, z/OS.
o Benefit: High availability, virtualization, storage and network stacks.
By user and task scope
Single-user, single-task:
o Idea: One user runs one program at a time (historical or specialized devices).
o Benefit: Simplicity.
Single-user, multitasking:
o Idea: One person runs many programs concurrently (typical PCs and phones).
o Benefit: Productivity and responsiveness.
Multi-user:
o Idea: Multiple people log in concurrently (servers, shared systems).
o Benefit: Resource sharing and centralized administration.
By kernel design (architecture)
Monolithic kernels:
o Idea: Most OS services run in kernel space for speed.
o Examples: Traditional UNIX, Linux.
o Trade-off: Larger trusted code base.
Microkernels:
o Idea: Minimal kernel, with services in user space for modularity and
reliability.
o Examples: MINIX microkernel line, QNX.
o Trade-off: More messaging overhead.
Hybrid kernels:
o Idea: Mix monolithic performance with microkernel modularity.
o Examples: Windows NT family, XNU in macOS.
o Benefit: Practical balance of speed and safety.
A compact comparison table
Easy2Siksha.com
Type
Typical features
Timing
constraints
Examples
Batch
Job control,
offline
processing
None;
throughput
oriented
Early mainframe
batch, modern
HPC schedulers
Time-sharing
Preemptive
scheduling,
many sessions
Soft;
responsive
feel
Windows, macOS,
Linux desktops
Real-time
Priority
scheduling,
bounded
latency
Hard or soft
deadlines
VxWorks,
FreeRTOS, QNX
Multiprocessing
SMP,
concurrency
control
None
specific
Windows/Linux on
multi-core
machines
Distributed
Resource
transparency,
messaging
Network-
dependent
Research OS,
clustered
UNIX/Linux
Network OS
File/print
services,
directory auth
None;
service-level
Windows Server,
UNIX servers
Embedded/Mobile
Small footprint,
power
management
Often
soft/hard RT
Android, iOS,
embedded Linux
Where you meet each type in real life
On your phone:
o OS: Android or iOS.
o Traits: Single-user, multitasking, mobile-focused, sandboxed apps, power-
aware.
On your laptop/PC:
o OS: Windows, macOS, Linux.
o Traits: Time-sharing, multitasking, GUI-rich, supports multiprocessing.
In your car and home devices:
Easy2Siksha.com
o OS: Embedded/RTOS (engine control, ABS), embedded Linux (TVs, routers).
o Traits: Deterministic response, small memory footprints, long-term reliability.
In offices and data centers:
o OS: Server OS (Windows Server, Linux, UNIX).
o Traits: Multi-user, strong networking, virtualization, clustering, high uptime.
In labs and industry:
o OS: Hard real-time or certified RTOS.
o Traits: Verified timing guarantees and safety-critical design.
A brief second story to cement the idea
Think of a city library. The OS is the head librarian. They issue library cards (user accounts),
set borrowing limits (permissions), file books (file system), hush the noisy patrons (process
isolation), reserve reading rooms (resource allocation), and coordinate deliveries with other
branches (networking). Visitors come and go, but the rules and order persistquietly
making everything work.
Exam-ready recap
Definition: An Operating System is the core system software that manages hardware
resources, provides abstractions and services to applications, and coordinates
execution, storage, I/O, security, and user interaction.
Key responsibilities:
o Process/CPU management: Scheduling, context switching, IPC.
o Memory management: Virtual memory, protection, paging.
o File/storage: Files, directories, caching, permissions.
o Device/I-O: Drivers, buffering, plug-and-play.
o Security/users: Authentication, authorization, isolation, auditing.
o Networking: Protocol stacks, sockets, firewalls.
o Interface: CLI shells and graphical desktops.
Different types of OS (with essence and uses):
o Batch: Non-interactive job queues; throughput.
o Time-sharing/multitasking: Interactive, many tasks/users; desktops.
o Real-time (hard/soft): Deadline-driven; control systems and devices.
Easy2Siksha.com
o Multiprogramming/multiprocessing: Keep CPU busy; leverage multiple
cores.
o Distributed and network OS: Coordinate machines; share resources.
o Embedded/mobile/desktop/server: Tuned for device class and purpose.
o Kernel architectures (monolithic, microkernel, hybrid): How the OS is built
internally.
Remember the stationmaster: the trains are your programs, the tracks are your hardware,
and the timetable is your OS. When the OS calls the signals, everything moves with purpose.
SECTION-C
5. Explain the features of MS-Word as a word processor.
Ans: The magic notebook on your desk
Imagine you find a notebook that writes with you. As you begin a sentence, it straightens
your handwriting, suggests better words, draws perfect tables when you sketch boxes, sticks
your photos neatly without glue, and even whispers, “Would you like a title page?” when it
sees a school project taking shape. That enchanted notebook is Microsoft Word. It doesn’t
just let you type; it helps you think clearer, organize faster, and present your ideas like they
deserve.
What Microsoft Word is
Microsoft Word is a full-featured word processor: software designed for creating, editing,
formatting, and sharing written documents. It sits between your ideas and the page, turning
keystrokes into clean paragraphs, simple outlines into polished reports, and rough drafts
into professional documents.
Core purpose: Write, edit, format, and finalize documents ranging from letters to
research reports and resumes.
Familiar interface: Ribbon tabs group tools (Home, Insert, Layout, References,
Review), while the Quick Access Toolbar keeps essentials in reach.
Backstage view: The File tab centralizes saving, exporting, printing, and document
info so production tasks don’t clutter your writing space.
Writing and editing essentials
Before a document looks good, it must read well. Word’s first superpowers live here.
Typing comfort: AutoCorrect fixes common typos as you go, while AutoText/Quick
Parts let you reuse standard phrases without retyping.
Easy2Siksha.com
Smart editing: Find and Replace hunts down words or patterns and can swap them
all at once, saving hours on global changes.
Spelling and grammar: The Editor panel underlines errors, suggests grammar fixes,
and offers clarity improvements to sharpen your tone.
Thesaurus and synonyms: Right-click to discover better word choices when a
sentence feels dull or repetitive.
Dictation and read aloud: Voice-to-text helps you draft hands-free; Read Aloud plays
your writing back so you catch awkward phrasing by ear.
Navigation pane: A sidebar lets you jump to headings, search content, and reorder
sections with drag-and-dropperfect for long reports.
Multiple views: Print Layout for exact pages, Web Layout for screen reading, Read
Mode for distraction-free review, and Outline View for restructuring.
Formatting and page layout
This is where a draft transforms into a document with presence and polish.
Character and paragraph formatting: Font, size, color, bold/italic, line spacing,
indents, alignment, borders, and shading give text its voice and rhythm.
Styles: Named sets (Heading 1, Normal, Quote) apply consistent formatting in a click
and build the backbone for tables of contents.
Themes: Coordinated fonts, colors, and effects unify the entire document’s look—
change a theme once, and everything stays in harmony.
Lists and numbering: Bullets, numbering, and multilevel lists organize ideas, steps,
and outlines with clean hierarchy.
Page setup: Control margins, orientation (portrait/landscape), paper size, and
columns to suit letters, reports, or brochures.
Headers and footers: Add page numbers, titles, dates, and logos that appear on
every pageor customize them per section.
Breaks and sections: Page and column breaks place content precisely; section breaks
let you mix layouts (like two-column text then a full-width chart).
Templates: Ready-made designs (resume, newsletter, research paper) jump-start a
professional layout without starting from scratch.
Structure, references, and long-document power
When your document grows, structure saves your sanityand impresses your examiner.
Headings and outline: Apply heading styles to build a clickable structure; Outline
View and the Navigation Pane make rearranging effortless.
Easy2Siksha.com
Table of contents: Auto-generate a TOC from headings, and update it as content
changesno manual renumbering.
Footnotes and endnotes: Add scholarly notes and references neatly at the page
bottom or document end.
Citations and bibliography: Manage sources (APA, MLA, Chicago), insert in-text
citations, and compile a bibliography that updates automatically.
Captions and cross-references: Label figures, tables, and equations; insert cross-
references that stay correct even after edits.
Index and table of figures: Mark terms to build an index; generate a table of figures
or tables for quick navigation in technical documents.
Document properties and inspector: Store author, title, and keywords; inspect and
remove hidden metadata before sharing.
Media, tables, and visual clarity
Words carry ideas; visuals make them stick. Word turns data and images into clean, aligned
components.
Pictures and icons: Insert photos, icons, and illustrations; use wrap text, align, crop,
and add effects for a polished look.
Shapes and SmartArt: Create diagrams for processes, hierarchies, and relationships
that explain better than paragraphs can.
Charts: Embed charts linked to Excel data so numbers stay accurate and visuals
update as data changes.
Text boxes and WordArt: Highlight key quotes, pullouts, or callouts without
disturbing the main flow of text.
Tables: Build structured grids for schedules, prices, or comparisons; sort data, merge
cells, add styles, and even do simple formulas.
Design consistency: Guides, alignment tools, and the grid ensure everything lines
upno tilted images or drifting captions.
Collaboration, review, and version control
Writing rarely happens alone. Word smooths group work, feedback, and change
management.
Track changes: Every insertion, deletion, and format tweak is marked with author
names and colorseasy to accept or reject later.
Comments and @mentions: Pin feedback to specific words or images, and notify
teammates right inside the document.
Easy2Siksha.com
Compare and combine: Merge edits from multiple reviewers into a single,
manageable history.
Co-authoring: Store the document in OneDrive or SharePoint to edit simultaneously
with others and watch updates flow in.
Language and translate: Set proofing language per section, translate selections or
full documents, and keep multilingual text consistent.
Accessibility checker: Spot issues like missing alt text or poor contrast so everyone
can read your work.
Word count and insights: Keep an eye on pages, words, characters, and reading
statistics for assignments with strict limits.
Productivity, automation, security, and sharing
These features save time, reduce errors, and keep your work safe from accidents and prying
eyes.
AutoSave and version history: Save continuously to the cloud and roll back to earlier
drafts when experiments go wrong.
Quick Parts and building blocks: Store reusable elements like signatures,
disclaimers, or formatted tables for one-click insertion.
Mail merge: Generate personalized letters, labels, and envelopes from a list of
namesperfect for invitations or notices.
Fields and content controls: Insert dynamic data (dates, page numbers, references)
and create forms with dropdowns and checkboxes.
Macros and VBA: Automate repetitive tasksfrom formatting cleanup to report
assemblywith recorded steps or small scripts.
Restrict editing: Limit changes to comments or tracked edits; lock sections to protect
exam answers or official templates.
Password protection and encryption: Require a password to open or modify,
keeping confidential documents private.
Digital signatures: Sign files to prove authenticity and integrityvital for official
submissions.
Export and print: Print with preview, adjust scaling, or export as PDF for a universal,
shareable final copy.
Integration with Office: Pull in Excel tables and charts, link PowerPoint snippets, and
cite sources managed across your Office ecosystem.
A short second story to remember it all
Easy2Siksha.com
Think of Word as a friendly stage manager. You write the script, but it cues the lights
(styles), moves the sets (layouts), hands props to actors (images and tables), records every
rehearsal change (track changes), and sends the final program to the printer just before the
audience sits down. You keep the creativity; Word keeps the show on time.
If the magic notebook had a motto, it would be: “You focus on ideas; I’ll take care of the
rest.” That’s the heart of MS Word as a word processor—helping you turn thoughts into
clean, credible, and compelling documents, with less effort and more confidence.
6. Explain how can you perform following operations in MS-Word:
(a) Creating lists and numbering
(b) Adding Header and Footer
(c) Finding and Replacing Text.
Ans: The backstage clipboard
Imagine you’re stage-managing a school play. Before the show, you make neat checklists for
props, label the top and bottom of every page in your binder so nothing gets lost, and
quickly swap any wrong character names wherever they appear. That backstage clipboard is
Microsoft Word in your handslists keep order, headers and footers keep context, and
Find/Replace cleans up mistakes before the curtain rises. Let’s walk through each operation
like a calm rehearsal: practical steps, small tricks, and a few “director’s notes” so your
document performs flawlessly.
Creating lists and numbering
Lists turn scattered thoughts into clear steps. Word gives you bullets, numbers, and
multilevel outlines that stay aligned and automatically renumber themselves as you edit.
Basic bullets and numbers
1. Start the list: Place the cursor where you want a list, then go to Home > Paragraph.
2. Choose bullets or numbers: Click Bullets for dot-style lists or Numbering for 1, 2, 3…
lists.
3. Type and break lines: Write your first item, press Enter to create the next, and keep
going.
4. End the list: Press Enter twice, or click the Bullets/Numbering button again to turn it
off.
Customizing bullets and numbers
1. Pick a style: Click the small arrow next to Bullets or Numbering to see different
designs.
Easy2Siksha.com
2. Use symbols or pictures: Choose Define New Bullet > Symbol or Picture to set a
custom bullet (e.g., arrows or checkmarks).
3. Change number format: Select Define New Number Format to switch to Roman
numerals, letters, or include punctuation like 1) or 1.your choice.
4. Adjust alignment and indents: Right-click a list > Adjust List Indents to fine-tune the
bullet/number position and text indent so everything lines up perfectly.
Multilevel lists (outlines)
1. Turn on multilevel: Click Multilevel List (next to Numbering) to choose a prebuilt
outline with multiple levels.
2. Promote/demote with Tab: Press Tab to move an item deeper (e.g., 1 → 1.1), and
Shift+Tab to move it back out.
3. Link to heading styles: Choose a multilevel format “linked to Heading styles.” Now
Heading 1 becomes Level 1 (1, 2, 3), Heading 2 becomes Level 2 (1.1, 1.2), and so
ongreat for reports.
4. Restart or continue numbering: Right-click a number > Restart at 1, or Continue
Numbering if Word didn’t guess your intent.
Quick list tricks
Convert lines to a list: Select several lines and click Bullets/Numbering to transform
them in one go.
Keep items together: Apply Keep with next (Layout > Paragraph > Line and Page
Breaks) to prevent an item from splitting awkwardly across pages.
Turn paragraphs into a checklist: Use a symbol bullet with a checkbox, or content
controls if you need clickable checkboxes in forms.
Director’s note: Lists aren’t just decoration. On screen, they’re fast to scan; on paper, they
anchor the eye. When in doubt, list it out.
Adding header and footer
Headers and footers are your page’s anchors—perfect for titles, dates, and page numbers.
They reduce confusion in printouts and make long documents feel professional and
consistent.
Opening and placing header/footer
1. Open the editor: Go to Insert > Header (or Footer) and choose a built-in style, or
click Edit Header/Footer to start from scratch.
2. Type content: Click in the header area (top margin) or footer area (bottom margin)
and type your textdocument title, course name, or your name and roll number.
Easy2Siksha.com
3. Add page numbers: Insert > Page Number lets you place numbers at top/bottom,
left/center/right, or even in the margin. Use Format Page Numbers to change format
(1, 2, 3 or i, ii, iii) or set a specific starting number.
4. Insert dynamic fields: Use Insert > Quick Parts > Field to add Date, Time, File Name,
Author, or Document Title so details update automatically.
5. Close the editor: Click Close Header and Footer on the ribbon or double-click back in
the main body.
Different first page, odd/even, and sections
1. Different first page: In the Header & Footer tab, check Different First Page to keep
your title page clean (no page number or header there), while all other pages have
them.
2. Different odd and even: Check Different Odd & Even Pages for book-style layouts
(e.g., page numbers mirrored at outer corners).
3. Change headers mid-document: Insert a Section Break (Layout > Breaks > Next
Page). Then, in the new section’s header, turn off Link to Previous so you can set a
unique header/footer for that section without affecting earlier pages.
4. Align and layout: Use the alignment tools (Left, Center, Right) and the header ruler
to ensure elements sit neatly and don’t collide with your text.
Polishing tips
Keep it simple: A clean header with document title and a footer with page number
often beats busy designs.
Consistent fonts: Match or complement body text fonts and sizes. Headers that
shout distract from the content.
Check print preview: File > Print shows if anything overhangs or looks misaligned on
paper.
Director’s note: Think of headers as signposts and footers as mile markers. Signposts tell
you where you are; mile markers tell you how far you’ve gone.
Finding and replacing text
Find/Replace is your time machine. It jumps you to any word in seconds and fixes repeated
mistakes everywhere at oncewithout tedious hunting.
Fast searching with the Navigation pane
1. Open search: Press Ctrl+F to open the Navigation pane.
2. Search keywords: Type a word or phrase. Word highlights results and lists them so
you can click to jump instantly.
Easy2Siksha.com
3. Browse by headings or pages: In the Navigation pane, switch tabs to see Headings
(great for long documents) or Pages (thumbnails you can click).
4. Reading highlight: In the Find options menu (or Advanced Find), use Reading
Highlight > Highlight All to illuminate every match on the page for quick visual
checks.
Precise find and replace
1. Open Replace: Press Ctrl+H to open Find and Replace.
2. Enter text: In Find what, type what you’re searching for. In Replace with, type the
new text.
3. Replace options: Click More >> to reveal powerful controls like Match case and Find
whole words only to avoid accidental changes (e.g., replacing “in” shouldn’t touch
“within”).
4. Preview and act: Click Find Next to preview each hit. Use Replace to change one, or
Replace All to change every occurrencecarefully.
Advanced techniques (formatting, wildcards, and specials)
1. Find by formatting: Click More >>, then Format. You can search for text with specific
formatting (e.g., Bold, a particular Style, or Font). In Replace with, set the new
formatting. This is brilliant for standardizing headings or fixing inconsistent italics.
2. Replace styles: In Find what, choose Format > Style and select, say, “Heading 2,”
then in Replace with choose a different style. Instantly remodels your structure
without retyping.
3. Special characters: Click Special to insert codes:
o Paragraph mark: ^p finds line breaks made by Enter.
o Tab character: ^t finds tabs in your text.
o Manual line break: ^l finds Shift+Enter breaks.
o Nonbreaking space: ^s finds protected spaces.
4. Wildcards for patterns: Check Use wildcards, then create patterns:
o Find words ending in “-ing”: typing “<[A-Za-z]{3,}ing>” locates whole words
with “-ing”; replace carefully.
o Swap name order: Find “([A-Za-z]+) ([A-Za-z]+)” and Replace with “\2 \1” to
flip “First Last” into “Last First.” Always test on a copy.
5. Replace with nothing: Leave Replace with empty to delete unwanted items (extra
spaces, stray tabs, duplicated punctuation).
Easy2Siksha.com
6. Scope your changes: Select a portion of text first if you only want replacements in
that region, then open Ctrl+HWord will limit the action to your selection.
Safety and speed tips
One round on a duplicate: Make a copy of your document and test tricky Replace All
operations there to avoid disasters.
Undo is your friend: If something goes wrong, Ctrl+Z steps you back through
changes.
Small batches: With complex wildcards or formatting, do a few replacements at a
time and review the results.
Consistent capitalization: Use Match case to preserve proper nouns and
abbreviations.
A short story to tie it together
Picture your document as that stage play. Your lists are the rehearsal planeveryone knows
their cues. The header and footer are the labels on each script pageno actor mixes Act II
with Act III. And Find/Replace? That’s your assistant quietly fixing every instance where
“Juliet” was misspelled “Juliett,” across 40 pages, in seconds. The audience never sees this
work, but they feel its smoothness.
SECTION-D
7. Which are different types of Graphs available in MS-Excel?
Ans: The chart gallery in Excel
Walk into a quiet gallery where each room turns numbers into pictures. One room shows
towers comparing heights, another traces delicate lines across time, a circular hall slices a
pie into tastes of a whole, and deeper in, maps paint countries with color. That gallery is
MS-Excel’s chart collection. If you know which room to enter, your data speaks clearlyno
shouting, no confusion, just the right frame for the right story.
What Excel charts are and why the type matters
Excel offers a family of chart typeseach optimized for a particular message. Pick the wrong
type, and you force the audience to decode; pick the right one, and they see the point
instantly. Think of “comparison,” “trend,” “distribution,” “composition,” “relationship,” and
“geography” as your six big questions. Each chart answers one best.
Core comparison and trend charts
Column (vertical) charts: Show comparisons across categories by height. Best when
category names sit along the bottom and you want to compare a few series side by
Easy2Siksha.com
side. Variants include Clustered (grouped series), Stacked (parts add to totals), and
100% Stacked (percentage share). 3-D versions exist, but 2-D is usually clearer.
Bar (horizontal) charts: Similar to column but turned sidewaysgreat for long
category labels or many categories. Useful for ranked lists like “Top 10 products.”
Clustered, Stacked, and 100% Stacked variants mirror column charts.
Line charts: Display trends over time or ordered categories. They emphasize
direction and rate of change. Use lines for continuous data (months, quarters, years).
Variants include lines with markers and stacked lines; consider smoothing sparingly.
Area charts: Fill the space under a line to highlight volume. Stacked area charts show
how parts contribute to a changing total over time; 100% stacked area shows
percentage contributions. Use when the cumulative whole matters, not just the
trend.
Combo charts: Combine types, like Column for sales and Line for profit margin, and
add a secondary axis for metrics on different scales. Excellent when you must
compare “apples and oranges” without distortion.
Composition and part-to-whole charts
Pie charts: Show a single series as slices of a whole (one time point). Keep slices to a
handful (ideally five or fewer). Explode a slice for emphasis, but avoid 3-D pies that
distort angles.
Doughnut charts: Like pie, but with a hole. They can display multiple rings (series) for
part-to-whole comparisons across categories. Use sparingly; multiple rings get hard
to read.
Waterfall charts: Reveal how sequential positive and negative changes build from a
starting value to an ending value—perfect for “bridge” views like operating profit
from revenue minus costs.
Funnel charts: Show progressive reduction across stages (e.g., leads → qualified →
proposals → wins). The shape makes drop-off obvious; avoid when stages don’t
strictly flow in one path.
Relationship and distribution charts
Scatter (XY) charts: Plot pairs of numerical values to reveal relationships, clusters,
and outliers. Ideal for showing correlation (height vs. weight) or calibrations. Add
trendlines to quantify relationships (linear, polynomial).
Bubble charts: An extension of scatter, where the bubble size encodes a third
variable (e.g., revenue by price and units). Keep labels or a legend clear; sizes should
be comparable.
Histogram charts: Automatically bin continuous data to show frequency distribution
(e.g., test scores). Adjust bin width to avoid over- or under-smoothing.
Easy2Siksha.com
Pareto charts: A special combo of columns sorted descending with a cumulative
percentage line. Great for “80/20” analysis—identify the few causes responsible for
most effects.
Box & Whisker charts: Summarize distribution with median, quartiles, and potential
outliers. Excellent for side-by-side comparison of variability across groups.
Structure, hierarchy, and category breakdowns
Treemap charts: Represent hierarchy as nested rectangles sized by value. Useful
when you want to compare parts within a whole across multiple levels (e.g., region
→ country → product).
Sunburst charts: Circular view of hierarchy with rings for levels. Intuitive when the
path from center (parent) to outer rings (children) matters more than precise area
comparison.
Radar (spider) charts: Plot multivariate profiles around a circle for side-by-side
comparison (e.g., competencies across teams). Great for patterns, not exact values.
Surface and contour charts: Show three-dimensional relationships (X, Y, and Z). A
surface chart is like a topographic map; use when the “landscape” matters (e.g.,
response surfaces in experiments).
Time series and finance
Stock charts: Designed for financial dataOpen-High-Low-Close (OHLC),
Volume-OHLC, and candlestick formats. They communicate range and volatility at a
glance.
Area/line variants for time: When volume or cumulative totals matter, choose area;
when direction and comparison matter, choose line.
Maps and geography
Filled Map (choropleth) charts: Color regions (countries, states, districts) by value.
Ideal for showing rates, densities, or totals across geography. Make sure you’re
comparing rates fairly; totals can mislead on large regions.
3D Maps (Power Map): Animate data over time on a globe or map, plot columns or
heat layers, and build tours. Best for presentations where spatial change over time
helps the story.
Small, fast, and analytical companions
Sparklines: Tiny, in-cell charts that show a row’s trend (line, column, or win/loss).
Great in dashboards where you scan many series quickly.
PivotCharts: Charts built from PivotTablesslice, filter, and drill into data
interactively without rebuilding the chart each time.
Easy2Siksha.com
Error bars, data labels, and trendlines: Not separate chart types, but vital add-ons
that improve interpretation and transparency.
When to use which chart
To compare categories: Column or bar; bar for long labels and many categories,
column for few categories and multiple series.
To show trends over time: Line for clear patterns; area if the magnitude under the
line matters; stacked area for changing parts of a whole.
To show parts of a whole: Pie or doughnut for a single moment and few slices; 100%
stacked column for comparisons across categories; waterfall for stepwise change.
To show relationships: Scatter for correlation; bubble for three variables in one
view.
To show distribution: Histogram for shape and spread; box & whisker for medians,
quartiles, and outliers across groups; Pareto for ranked causes and cumulative
impact.
To show hierarchy: Treemap for space-efficient overviews; sunburst for
path-oriented hierarchies.
To show process drop-off: Funnel, when stages are sequential and comparable.
To show geography: Filled map for regional comparisons; 3D Map for animated,
spatiotemporal stories.
To combine metrics: Combo charts with a secondary axis when scales differ
meaningfully.
Practical selection tips that make exam answers shine
Start with the question: What do I want the viewer to see first?” Choose the chart
that naturally emphasizes that message.
Reduce clutter: Avoid 3-D effects unless they add genuine value; they often distort
perception.
Limit categories and series: Too many colors collapse into noise. If it needs a legend
decoder ring, it’s probably the wrong chart.
Use consistent scales: When comparing series, aligned axes prevent misleading
conclusions.
Label thoughtfully: Data labels, clear titles, and concise axis names turn a good chart
into a great one.
Color with purpose: Use one highlight color to pull attention to the main point; keep
the rest neutral.
Easy2Siksha.com
A short second story to lock it in
Imagine your data as a choir. Column charts are the strong altos, keeping steady rhythm
with clear comparisons. Line charts are the soaring sopranos tracing melodies of change.
Pies sing the harmonies of a single chord, while scatter plots reveal duetshow one voice
blends with another. Choose the right voices, and your audience hears the music, not the
math.
8. Which are various views of slides available in MS-PowerPoint?
Ans: The projectionist’s rooms
Imagine an old cinema with many small rooms behind the screen. In one room, the
projectionist splices film scenes together; in another, they pin storyboards on a wall to
rearrange sequences; elsewhere, they scribble notes on cue cards; and finally, they dim the
lights to watch the show exactly as the audience will. PowerPoint’s views are those rooms.
Each view changes how you look at your slides so you can write, organize, rehearse, and
present with control and calm.
What slide views are
PowerPoint’s “views” are different ways to look at and work on the same slide deck. They
don’t change your content; they change your workspace to suit the taskwriting text,
structuring a story, arranging order, adding speaker notes, or delivering the slideshow. The
View tab and the status bar (at the bottom) let you switch between them quickly.
Core editing views
Normal view
Best for: Drafting slides, placing text and images, and working one slide at a time.
What you see: The main canvas (current slide), a thumbnail pane on the left, and a
notes pane at the bottom.
How to open: View > Normal, or click the Normal icon on the status bar.
Why it matters:
o Focused crafting: You refine layout, fonts, and visuals on a single slide.
o Quick navigation: Thumbnails let you jump, duplicate, hide, or delete slides.
o Notes at hand: The notes pane keeps your speaking points close without
cluttering the slide.
Outline view
Best for: Structuring your story with text firsttitles and bullet pointsbefore
design.
Easy2Siksha.com
What you see: A text-only outline (titles and bullet lists) in the left pane; the slide
canvas remains visible.
How to open: View > Outline View.
Why it matters:
o Fast restructuring: Promote/demote bullets with Tab/Shift+Tab; drag text
items to reorder content across slides.
o Content-first workflow: Ensures your argument flows before you worry
about visuals.
Organizing and sequencing
Slide sorter view
Best for: Reordering slides, grouping sections, and spotting pacing problems.
What you see: A grid of slide thumbnails without the distraction of the editing
canvas.
How to open: View > Slide Sorter, or click the Slide Sorter icon on the status bar.
Why it matters:
o Big-picture control: You can rearrange by dragging, select multiples,
copy/paste, and delete in bulk.
o Section management: Add section breaks, name them, and collapse/expand
to manage long decks.
o Timing rehearsal: Apply or view transitions and their timings across slides at
a glance.
Rehearsal and delivery
Slide show view
Best for: Presenting full-screen, exactly as your audience sees it.
What you see: Your slides fill the screen; transitions and animations play.
How to open: Slide Show > From Beginning (or press F5), or Slide Show > From
Current Slide (Shift+F5).
Why it matters:
o Final check: Test animations, media playback, and legibility.
o Live delivery: Navigate with arrow keys; use B to black out or W to white out
the screen for emphasis.
Presenter view
Easy2Siksha.com
Best for: Presenting with two screensone for the audience, one private control
screen for you.
What you see (on your screen): Current slide, next slide preview, your speaker
notes, a timer, and navigation tools.
How to open: Slide Show > Use Presenter View (auto-enables with two displays).
Why it matters:
o Calm control: See what’s next without turning your back.
o Note confidence: Your cues are visible to you, invisible to the audience.
Reading view
Best for: Reviewing the slideshow in a window without going full-screen.
What you see: Slides play with transitions in a framed window; your taskbar remains
accessible.
How to open: View > Reading View, or click the Reading icon on the status bar.
Why it matters:
o Quick checks: Preview animations while keeping other apps handy.
o Screen-sharing ease: Ideal for online demos where full-screen may disrupt
other controls.
Notes and handouts
Notes page view
Best for: Writing and formatting speaker notes and preparing notes printouts.
What you see: Each slide paired with its notes area on a printable page.
How to open: View > Notes Page.
Why it matters:
o Presenter script: Compose detailed talking points beyond the tiny notes
pane.
o Polished printouts: Add images, tables, or diagrams to notes that help you
(or others) present.
Handout master
Best for: Designing the layout of printed handouts (2, 3, 4, 6, or 9 slides per page).
What you see: A master page controlling header/footer, date, page numbers, and
background for handout printouts.
Easy2Siksha.com
How to open: View > Master Views > Handout Master.
Why it matters:
o Consistent branding: Place logos and footers on every handout page.
o Clean give-aways: Three-slides-with-notes layout gives audience space to
scribble.
Design control across the deck
Slide master view
Best for: Setting global designfonts, colors, backgrounds, and default layouts for
every slide.
What you see: A hierarchy of masters and layouts representing your theme.
How to open: View > Slide Master.
Why it matters:
o One change, everywhere: Update a font or placeholder once; all slides follow.
o Layout discipline: Create custom layouts (e.g., “Quote slide,” “Comparison”)
so content stays consistent as you build.
Notes master
Best for: Styling the look of Notes Page printouts globally.
What you see: A master for notes page elementsheaders, footers, and positions.
How to open: View > Master Views > Notes Master.
Why it matters:
o Readable scripts: Standardize fonts and spacing in speaker notes for comfort
at the podium.
o Professional packets: If you share notes decks, they’ll look intentional, not
accidental.
Lesser-known helpers (not separate views, but worth knowing)
Guides and gridlines:
o Use: Align objects precisely in Normal view.
o Why it helps: Clean alignment makes slides look high-end without extra
effort.
Section headers and summary zoom (feature):
o Use: Organize parts of your story and create a clickable overview slide.
Easy2Siksha.com
o Why it helps: Lets you navigate nonlinearly during Q&A without losing your
audience.
Zoom control:
o Use: Inspect small details in Normal view; step back for the whole slide.
o Why it helps: Prevents tiny typos and misalignments from slipping through.
Choosing the right view for the job
Drafting content:
o Pick: Normal view or Outline view.
o Reason: Write freely, structure titles and bullets, and keep notes nearby.
Reordering and pacing:
o Pick: Slide sorter.
o Reason: See the arc of your story and fix choppy sequences fast.
Design consistency:
o Pick: Slide master.
o Reason: Set the visual rules once; stop fixing slide-by-slide.
Speaker support:
o Pick: Notes page to write; Presenter view to deliver.
o Reason: Prepare your voice offstage; perform with confidence onstage.
Final checks and sharing:
o Pick: Reading view for quick preview; Slide show for full dress rehearsal.
o Reason: Catch animation timing, legibility, and flow before showtime.
Quick comparison at a glance
View
Best for
How to open
Key tip
Normal
Slide-by-slide editing
View > Normal
Use the notes pane for
speaker cues
Outline
Structuring text
View > Outline View
Tab/Shift+Tab to
promote/demote points
Slide Sorter
Reordering and
pacing
View > Slide Sorter
Group slides into named
sections
Easy2Siksha.com
Notes Page
Writing printable
notes
View > Notes Page
Add images to notes for
memory cues
Slide Master
Global design and
layouts
View > Slide Master
Create custom layouts for
repeat patterns
Handout
Master
Printed audience
handouts
View > Handout
Master
Include headers/footers and
page numbers
Reading
Preview in a window
View > Reading
View
Great for screen shares
without full-screen
Slide Show
Presenting full-
screen
Slide Show > From
Beginning (F5)
Shift+F5 starts from current
slide
Presenter
Delivering with notes
on 2 screens
Slide Show > Use
Presenter View
Timer and next-slide
preview calm nerves
A short second story to fix the idea
Think of your deck as a novel. Normal view is your writing desk; Outline view is the index
cards you shuffle to perfect the plot; Slide Sorter is the corkboard where chapters snap into
order; Slide Master is your style guide; Notes Page is the margin where the narrator
whispers; Reading view is the proof copy; Presenter view and Slide Show are opening night.
Same story, different rooms, each one sharpening the performance.
“This paper has been carefully prepared for educational purposes. If you notice any mistakes or
have suggestions, feel free to share your feedback.”